<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DsSoDu" targetNamespace="http://tempuri.org/DsSoDu.xsd" xmlns:mstns="http://tempuri.org/DsSoDu.xsd" xmlns="http://tempuri.org/DsSoDu.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="4" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Accounting3ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Accounting3ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KeToanTongHop.Properties.Settings.GlobalReference.Default.Accounting3ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SieuThiSachConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SieuThiSachConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KeToanTongHop.Properties.Settings.GlobalReference.Default.SieuThiSachConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AccountingGuidConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="AccountingGuidConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KeToanTongHop.Properties.Settings.GlobalReference.Default.AccountingGuidConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CPINConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CPINConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KeToanTongHop.Properties.Settings.GlobalReference.Default.CPINConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CPINConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CPINConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KeToanTongHop.Properties.Settings.GlobalReference.Default.CPINConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SoDuNgoaiTeTableAdapter" GeneratorDataComponentClassName="SoDuNgoaiTeTableAdapter" Name="SoDuNgoaiTe" UserDataComponentName="SoDuNgoaiTeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Accounting3ConnectionString (Settings)" DbObjectName="Accounting3.dbo.SoDuNgoaiTe" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [SoDuNgoaiTe] WHERE (([ThoiDiemKhoaSoID] = @Original_ThoiDiemKhoaSoID) AND ([TaiKhoanID] = @Original_TaiKhoanID) AND ([TienTeID] = @Original_TienTeID) AND ([SoDu] = @Original_SoDu) AND ([TyGia] = @Original_TyGia) AND ([QuyDoi] = @Original_QuyDoi))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ThoiDiemKhoaSoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThoiDiemKhoaSoID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiKhoanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TienTeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TienTeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_SoDu" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SoDu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TyGia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TyGia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_QuyDoi" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="QuyDoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [SoDuNgoaiTe] ([ThoiDiemKhoaSoID], [TaiKhoanID], [TienTeID], [SoDu], [TyGia], [QuyDoi]) VALUES (@ThoiDiemKhoaSoID, @TaiKhoanID, @TienTeID, @SoDu, @TyGia, @QuyDoi);
SELECT ThoiDiemKhoaSoID, TaiKhoanID, TienTeID, SoDu, TyGia, QuyDoi FROM SoDuNgoaiTe WHERE (TaiKhoanID = @TaiKhoanID) AND (ThoiDiemKhoaSoID = @ThoiDiemKhoaSoID) AND (TienTeID = @TienTeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ThoiDiemKhoaSoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThoiDiemKhoaSoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TaiKhoanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TienTeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TienTeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@SoDu" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SoDu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TyGia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TyGia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@QuyDoi" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="QuyDoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM SoDuNgoaiTe</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [SoDuNgoaiTe] SET [ThoiDiemKhoaSoID] = @ThoiDiemKhoaSoID, [TaiKhoanID] = @TaiKhoanID, [TienTeID] = @TienTeID, [SoDu] = @SoDu, [TyGia] = @TyGia, [QuyDoi] = @QuyDoi WHERE (([ThoiDiemKhoaSoID] = @Original_ThoiDiemKhoaSoID) AND ([TaiKhoanID] = @Original_TaiKhoanID) AND ([TienTeID] = @Original_TienTeID) AND ([SoDu] = @Original_SoDu) AND ([TyGia] = @Original_TyGia) AND ([QuyDoi] = @Original_QuyDoi));
SELECT ThoiDiemKhoaSoID, TaiKhoanID, TienTeID, SoDu, TyGia, QuyDoi FROM SoDuNgoaiTe WHERE (TaiKhoanID = @TaiKhoanID) AND (ThoiDiemKhoaSoID = @ThoiDiemKhoaSoID) AND (TienTeID = @TienTeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ThoiDiemKhoaSoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThoiDiemKhoaSoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TaiKhoanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TienTeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TienTeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@SoDu" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SoDu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TyGia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TyGia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@QuyDoi" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="QuyDoi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ThoiDiemKhoaSoID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThoiDiemKhoaSoID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaiKhoanID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaiKhoanID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TienTeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TienTeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_SoDu" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SoDu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TyGia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TyGia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_QuyDoi" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="QuyDoi" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ThoiDiemKhoaSoID" DataSetColumn="ThoiDiemKhoaSoID" />
              <Mapping SourceColumn="TaiKhoanID" DataSetColumn="TaiKhoanID" />
              <Mapping SourceColumn="TienTeID" DataSetColumn="TienTeID" />
              <Mapping SourceColumn="SoDu" DataSetColumn="SoDu" />
              <Mapping SourceColumn="TyGia" DataSetColumn="TyGia" />
              <Mapping SourceColumn="QuyDoi" DataSetColumn="QuyDoi" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ThoiDiemKhoaSoTableAdapter" GeneratorDataComponentClassName="ThoiDiemKhoaSoTableAdapter" Name="ThoiDiemKhoaSo" UserDataComponentName="ThoiDiemKhoaSoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SieuThiSachConnectionString (Settings)" DbObjectName="SieuThiSach.dbo.ThoiDiemKhoaSo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [ThoiDiemKhoaSo] WHERE (([ID] = @Original_ID) AND ([ThoiDiem] = @Original_ThoiDiem) AND ([ThucHienChotSoDu] = @Original_ThucHienChotSoDu) AND ((@IsNull_DienGiai = 1 AND [DienGiai] IS NULL) OR ([DienGiai] = @Original_DienGiai)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ThoiDiem" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ThoiDiem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ThucHienChotSoDu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ThucHienChotSoDu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienGiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienGiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [ThoiDiemKhoaSo] ([ID], [ThoiDiem], [ThucHienChotSoDu], [DienGiai]) VALUES (@ID, @ThoiDiem, @ThucHienChotSoDu, @DienGiai);
SELECT ID, ThoiDiem, ThucHienChotSoDu, DienGiai FROM ThoiDiemKhoaSo WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ThoiDiem" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ThoiDiem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ThucHienChotSoDu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ThucHienChotSoDu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienGiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM ThoiDiemKhoaSo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [ThoiDiemKhoaSo] SET [ID] = @ID, [ThoiDiem] = @ThoiDiem, [ThucHienChotSoDu] = @ThucHienChotSoDu, [DienGiai] = @DienGiai WHERE (([ID] = @Original_ID) AND ([ThoiDiem] = @Original_ThoiDiem) AND ([ThucHienChotSoDu] = @Original_ThucHienChotSoDu) AND ((@IsNull_DienGiai = 1 AND [DienGiai] IS NULL) OR ([DienGiai] = @Original_DienGiai)));
SELECT ID, ThoiDiem, ThucHienChotSoDu, DienGiai FROM ThoiDiemKhoaSo WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ThoiDiem" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ThoiDiem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ThucHienChotSoDu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ThucHienChotSoDu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienGiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ThoiDiem" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ThoiDiem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ThucHienChotSoDu" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ThucHienChotSoDu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienGiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienGiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ThoiDiem" DataSetColumn="ThoiDiem" />
              <Mapping SourceColumn="ThucHienChotSoDu" DataSetColumn="ThucHienChotSoDu" />
              <Mapping SourceColumn="DienGiai" DataSetColumn="DienGiai" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TonPhiMuaHangTableAdapter" GeneratorDataComponentClassName="TonPhiMuaHangTableAdapter" Name="TonPhiMuaHang" UserDataComponentName="TonPhiMuaHangTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AccountingGuidConnectionString (Settings)" DbObjectName="AccountingGuid.dbo.TonPhiMuaHang" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [TonPhiMuaHang] ([ThoiDiemKhoaSoID], [VatTuHangHoaID], [GiaTri]) VALUES (@ThoiDiemKhoaSoID, @VatTuHangHoaID, @GiaTri)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ThoiDiemKhoaSoID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ThoiDiemKhoaSoID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@VatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="VatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaTri" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaTri" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM TonPhiMuaHang</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ThoiDiemKhoaSoID" DataSetColumn="ThoiDiemKhoaSoID" />
              <Mapping SourceColumn="VatTuHangHoaID" DataSetColumn="VatTuHangHoaID" />
              <Mapping SourceColumn="GiaTri" DataSetColumn="GiaTri" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TonKhoTableAdapter" GeneratorDataComponentClassName="TonKhoTableAdapter" Name="TonKho" UserDataComponentName="TonKhoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CPINConnectionString1 (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT A.*, B.Ma MaHang, B.Ten TenHang, B.GiaBia, B.GiaBia* A.Soluong 'ThanhTienGiaBia', C.Ten TenKho
FROM TonKho A INNER JOIN VatTuHangHoa B ON A.VatTuHangHoaID = B.ID
INNER JOIN Kho C ON A.KhoID = C.ID </CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ThoiDiemKhoaSoID" DataSetColumn="ThoiDiemKhoaSoID" />
              <Mapping SourceColumn="KhoID" DataSetColumn="KhoID" />
              <Mapping SourceColumn="VatTuHangHoaID" DataSetColumn="VatTuHangHoaID" />
              <Mapping SourceColumn="SoLuong" DataSetColumn="SoLuong" />
              <Mapping SourceColumn="DonGia" DataSetColumn="DonGia" />
              <Mapping SourceColumn="ThanhTien" DataSetColumn="ThanhTien" />
              <Mapping SourceColumn="MaHang" DataSetColumn="MaHang" />
              <Mapping SourceColumn="TenHang" DataSetColumn="TenHang" />
              <Mapping SourceColumn="GiaBia" DataSetColumn="GiaBia" />
              <Mapping SourceColumn="ThanhTienGiaBia" DataSetColumn="ThanhTienGiaBia" />
              <Mapping SourceColumn="TenKho" DataSetColumn="TenKho" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DsSoDu" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DsSoDu" msprop:Generator_DataSetName="DsSoDu">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="SoDuTaiKhoan" msprop:Generator_UserTableName="SoDuTaiKhoan" msprop:Generator_RowDeletedName="SoDuTaiKhoanRowDeleted" msprop:Generator_RowChangedName="SoDuTaiKhoanRowChanged" msprop:Generator_RowClassName="SoDuTaiKhoanRow" msprop:Generator_RowChangingName="SoDuTaiKhoanRowChanging" msprop:Generator_RowEvArgName="SoDuTaiKhoanRowChangeEvent" msprop:Generator_RowEvHandlerName="SoDuTaiKhoanRowChangeEventHandler" msprop:Generator_TableClassName="SoDuTaiKhoanDataTable" msprop:Generator_TableVarName="tableSoDuTaiKhoan" msprop:Generator_RowDeletingName="SoDuTaiKhoanRowDeleting" msprop:Generator_TablePropName="SoDuTaiKhoan">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ThoiDiemKhoaSoID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInRow="ThoiDiemKhoaSoID" msprop:Generator_ColumnVarNameInTable="columnThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInTable="ThoiDiemKhoaSoIDColumn" type="xs:string" />
              <xs:element name="TaiKhoanID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="TaiKhoanID" msprop:Generator_ColumnPropNameInRow="TaiKhoanID" msprop:Generator_ColumnVarNameInTable="columnTaiKhoanID" msprop:Generator_ColumnPropNameInTable="TaiKhoanIDColumn" type="xs:string" />
              <xs:element name="TaiKhoanIDForSoHieu" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="TaiKhoanIDForSoHieu" msprop:Generator_ColumnPropNameInRow="TaiKhoanIDForSoHieu" msprop:Generator_ColumnVarNameInTable="columnTaiKhoanIDForSoHieu" msprop:Generator_ColumnPropNameInTable="TaiKhoanIDForSoHieuColumn" type="xs:string" minOccurs="0" />
              <xs:element name="DuNo" msprop:Generator_UserColumnName="DuNo" msprop:Generator_ColumnPropNameInRow="DuNo" msprop:Generator_ColumnVarNameInTable="columnDuNo" msprop:Generator_ColumnPropNameInTable="DuNoColumn" type="xs:decimal" />
              <xs:element name="DuCo" msprop:Generator_UserColumnName="DuCo" msprop:Generator_ColumnPropNameInRow="DuCo" msprop:Generator_ColumnVarNameInTable="columnDuCo" msprop:Generator_ColumnPropNameInTable="DuCoColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SoDuNgoaiTe" msprop:Generator_UserTableName="SoDuNgoaiTe" msprop:Generator_RowDeletedName="SoDuNgoaiTeRowDeleted" msprop:Generator_RowChangedName="SoDuNgoaiTeRowChanged" msprop:Generator_RowClassName="SoDuNgoaiTeRow" msprop:Generator_RowChangingName="SoDuNgoaiTeRowChanging" msprop:Generator_RowEvArgName="SoDuNgoaiTeRowChangeEvent" msprop:Generator_RowEvHandlerName="SoDuNgoaiTeRowChangeEventHandler" msprop:Generator_TableClassName="SoDuNgoaiTeDataTable" msprop:Generator_TableVarName="tableSoDuNgoaiTe" msprop:Generator_RowDeletingName="SoDuNgoaiTeRowDeleting" msprop:Generator_TablePropName="SoDuNgoaiTe">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ThoiDiemKhoaSoID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInRow="ThoiDiemKhoaSoID" msprop:Generator_ColumnVarNameInTable="columnThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInTable="ThoiDiemKhoaSoIDColumn" type="xs:string" />
              <xs:element name="TaiKhoanID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="TaiKhoanID" msprop:Generator_ColumnPropNameInRow="TaiKhoanID" msprop:Generator_ColumnVarNameInTable="columnTaiKhoanID" msprop:Generator_ColumnPropNameInTable="TaiKhoanIDColumn" type="xs:string" />
              <xs:element name="TienTeID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="TienTeID" msprop:Generator_ColumnPropNameInRow="TienTeID" msprop:Generator_ColumnVarNameInTable="columnTienTeID" msprop:Generator_ColumnPropNameInTable="TienTeIDColumn" type="xs:string" />
              <xs:element name="SoDu" msprop:Generator_UserColumnName="SoDu" msprop:Generator_ColumnPropNameInRow="SoDu" msprop:Generator_ColumnVarNameInTable="columnSoDu" msprop:Generator_ColumnPropNameInTable="SoDuColumn" type="xs:decimal" />
              <xs:element name="TyGia" msprop:Generator_UserColumnName="TyGia" msprop:Generator_ColumnPropNameInRow="TyGia" msprop:Generator_ColumnVarNameInTable="columnTyGia" msprop:Generator_ColumnPropNameInTable="TyGiaColumn" type="xs:decimal" />
              <xs:element name="QuyDoi" msprop:Generator_UserColumnName="QuyDoi" msprop:Generator_ColumnPropNameInRow="QuyDoi" msprop:Generator_ColumnVarNameInTable="columnQuyDoi" msprop:Generator_ColumnPropNameInTable="QuyDoiColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SoDuTheoDoiTuong" msprop:Generator_UserTableName="SoDuTheoDoiTuong" msprop:Generator_RowDeletedName="SoDuTheoDoiTuongRowDeleted" msprop:Generator_RowChangedName="SoDuTheoDoiTuongRowChanged" msprop:Generator_RowClassName="SoDuTheoDoiTuongRow" msprop:Generator_RowChangingName="SoDuTheoDoiTuongRowChanging" msprop:Generator_RowEvArgName="SoDuTheoDoiTuongRowChangeEvent" msprop:Generator_RowEvHandlerName="SoDuTheoDoiTuongRowChangeEventHandler" msprop:Generator_TableClassName="SoDuTheoDoiTuongDataTable" msprop:Generator_TableVarName="tableSoDuTheoDoiTuong" msprop:Generator_RowDeletingName="SoDuTheoDoiTuongRowDeleting" msprop:Generator_TablePropName="SoDuTheoDoiTuong">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ThoiDiemKhoaSoID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ThoiDiemKhoaSoID" msprop:Generator_ColumnVarNameInTable="columnThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInRow="ThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInTable="ThoiDiemKhoaSoIDColumn" type="xs:string" />
              <xs:element name="TaiKhoanID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="TaiKhoanID" msprop:Generator_ColumnVarNameInTable="columnTaiKhoanID" msprop:Generator_ColumnPropNameInRow="TaiKhoanID" msprop:Generator_ColumnPropNameInTable="TaiKhoanIDColumn" type="xs:string" />
              <xs:element name="DoiTuongNghiepVuID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="DoiTuongNghiepVuID" msprop:Generator_ColumnVarNameInTable="columnDoiTuongNghiepVuID" msprop:Generator_ColumnPropNameInRow="DoiTuongNghiepVuID" msprop:Generator_ColumnPropNameInTable="DoiTuongNghiepVuIDColumn" type="xs:string" />
              <xs:element name="DoiTuongNghiepVu1ID" msprop:Generator_UserColumnName="DoiTuongNghiepVu1ID" msprop:Generator_ColumnVarNameInTable="columnDoiTuongNghiepVu1ID" msprop:Generator_ColumnPropNameInRow="DoiTuongNghiepVu1ID" msprop:Generator_ColumnPropNameInTable="DoiTuongNghiepVu1IDColumn" type="xs:string" minOccurs="0" />
              <xs:element name="DuNo" msprop:Generator_UserColumnName="DuNo" msprop:Generator_ColumnVarNameInTable="columnDuNo" msprop:Generator_ColumnPropNameInRow="DuNo" msprop:Generator_ColumnPropNameInTable="DuNoColumn" type="xs:decimal" />
              <xs:element name="DuCo" msprop:Generator_UserColumnName="DuCo" msprop:Generator_ColumnVarNameInTable="columnDuCo" msprop:Generator_ColumnPropNameInRow="DuCo" msprop:Generator_ColumnPropNameInTable="DuCoColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ThoiDiemKhoaSo" msprop:Generator_UserTableName="ThoiDiemKhoaSo" msprop:Generator_RowDeletedName="ThoiDiemKhoaSoRowDeleted" msprop:Generator_RowChangedName="ThoiDiemKhoaSoRowChanged" msprop:Generator_RowClassName="ThoiDiemKhoaSoRow" msprop:Generator_RowChangingName="ThoiDiemKhoaSoRowChanging" msprop:Generator_RowEvArgName="ThoiDiemKhoaSoRowChangeEvent" msprop:Generator_RowEvHandlerName="ThoiDiemKhoaSoRowChangeEventHandler" msprop:Generator_TableClassName="ThoiDiemKhoaSoDataTable" msprop:Generator_TableVarName="tableThoiDiemKhoaSo" msprop:Generator_RowDeletingName="ThoiDiemKhoaSoRowDeleting" msprop:Generator_TablePropName="ThoiDiemKhoaSo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="ThoiDiem" msprop:Generator_UserColumnName="ThoiDiem" msprop:Generator_ColumnPropNameInRow="ThoiDiem" msprop:Generator_ColumnVarNameInTable="columnThoiDiem" msprop:Generator_ColumnPropNameInTable="ThoiDiemColumn" type="xs:dateTime" />
              <xs:element name="ThucHienChotSoDu" msprop:Generator_UserColumnName="ThucHienChotSoDu" msprop:Generator_ColumnPropNameInRow="ThucHienChotSoDu" msprop:Generator_ColumnVarNameInTable="columnThucHienChotSoDu" msprop:Generator_ColumnPropNameInTable="ThucHienChotSoDuColumn" type="xs:boolean" />
              <xs:element name="DienGiai" msprop:Generator_UserColumnName="DienGiai" msprop:Generator_ColumnPropNameInRow="DienGiai" msprop:Generator_ColumnVarNameInTable="columnDienGiai" msprop:Generator_ColumnPropNameInTable="DienGiaiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TonPhiMuaHang" msprop:Generator_UserTableName="TonPhiMuaHang" msprop:Generator_RowDeletedName="TonPhiMuaHangRowDeleted" msprop:Generator_RowChangedName="TonPhiMuaHangRowChanged" msprop:Generator_RowClassName="TonPhiMuaHangRow" msprop:Generator_RowChangingName="TonPhiMuaHangRowChanging" msprop:Generator_RowEvArgName="TonPhiMuaHangRowChangeEvent" msprop:Generator_RowEvHandlerName="TonPhiMuaHangRowChangeEventHandler" msprop:Generator_TableClassName="TonPhiMuaHangDataTable" msprop:Generator_TableVarName="tableTonPhiMuaHang" msprop:Generator_RowDeletingName="TonPhiMuaHangRowDeleting" msprop:Generator_TablePropName="TonPhiMuaHang">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ThoiDiemKhoaSoID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ThoiDiemKhoaSoID" msprop:Generator_ColumnVarNameInTable="columnThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInRow="ThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInTable="ThoiDiemKhoaSoIDColumn" type="xs:string" />
              <xs:element name="VatTuHangHoaID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="VatTuHangHoaID" msprop:Generator_ColumnVarNameInTable="columnVatTuHangHoaID" msprop:Generator_ColumnPropNameInRow="VatTuHangHoaID" msprop:Generator_ColumnPropNameInTable="VatTuHangHoaIDColumn" type="xs:string" />
              <xs:element name="GiaTri" msprop:Generator_UserColumnName="GiaTri" msprop:Generator_ColumnVarNameInTable="columnGiaTri" msprop:Generator_ColumnPropNameInRow="GiaTri" msprop:Generator_ColumnPropNameInTable="GiaTriColumn" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TonKho" msprop:Generator_UserTableName="TonKho" msprop:Generator_RowDeletedName="TonKhoRowDeleted" msprop:Generator_TableClassName="TonKhoDataTable" msprop:Generator_RowChangedName="TonKhoRowChanged" msprop:Generator_RowClassName="TonKhoRow" msprop:Generator_RowChangingName="TonKhoRowChanging" msprop:Generator_RowEvArgName="TonKhoRowChangeEvent" msprop:Generator_RowEvHandlerName="TonKhoRowChangeEventHandler" msprop:Generator_TablePropName="TonKho" msprop:Generator_TableVarName="tableTonKho" msprop:Generator_RowDeletingName="TonKhoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="ThoiDiemKhoaSoID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInRow="ThoiDiemKhoaSoID" msprop:Generator_ColumnVarNameInTable="columnThoiDiemKhoaSoID" msprop:Generator_ColumnPropNameInTable="ThoiDiemKhoaSoIDColumn" type="xs:string" />
              <xs:element name="KhoID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="KhoID" msprop:Generator_ColumnPropNameInRow="KhoID" msprop:Generator_ColumnVarNameInTable="columnKhoID" msprop:Generator_ColumnPropNameInTable="KhoIDColumn" type="xs:string" />
              <xs:element name="VatTuHangHoaID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="VatTuHangHoaID" msprop:Generator_ColumnPropNameInRow="VatTuHangHoaID" msprop:Generator_ColumnVarNameInTable="columnVatTuHangHoaID" msprop:Generator_ColumnPropNameInTable="VatTuHangHoaIDColumn" type="xs:string" />
              <xs:element name="SoLuong" msprop:Generator_UserColumnName="SoLuong" msprop:Generator_ColumnPropNameInRow="SoLuong" msprop:Generator_ColumnVarNameInTable="columnSoLuong" msprop:Generator_ColumnPropNameInTable="SoLuongColumn" type="xs:decimal" />
              <xs:element name="DonGia" msprop:Generator_UserColumnName="DonGia" msprop:Generator_ColumnPropNameInRow="DonGia" msprop:Generator_ColumnVarNameInTable="columnDonGia" msprop:Generator_ColumnPropNameInTable="DonGiaColumn" type="xs:decimal" />
              <xs:element name="ThanhTien" msprop:Generator_UserColumnName="ThanhTien" msprop:Generator_ColumnPropNameInRow="ThanhTien" msprop:Generator_ColumnVarNameInTable="columnThanhTien" msprop:Generator_ColumnPropNameInTable="ThanhTienColumn" type="xs:decimal" />
              <xs:element name="MaHang" msprop:Generator_UserColumnName="MaHang" msprop:Generator_ColumnPropNameInRow="MaHang" msprop:Generator_ColumnVarNameInTable="columnMaHang" msprop:Generator_ColumnPropNameInTable="MaHangColumn" type="xs:string" />
              <xs:element name="TenHang" msprop:Generator_UserColumnName="TenHang" msprop:Generator_ColumnPropNameInRow="TenHang" msprop:Generator_ColumnVarNameInTable="columnTenHang" msprop:Generator_ColumnPropNameInTable="TenHangColumn" type="xs:string" minOccurs="0" />
              <xs:element name="GiaBia" msprop:Generator_UserColumnName="GiaBia" msprop:Generator_ColumnPropNameInRow="GiaBia" msprop:Generator_ColumnVarNameInTable="columnGiaBia" msprop:Generator_ColumnPropNameInTable="GiaBiaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ThanhTienGiaBia" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ThanhTienGiaBia" msprop:Generator_ColumnPropNameInRow="ThanhTienGiaBia" msprop:Generator_ColumnVarNameInTable="columnThanhTienGiaBia" msprop:Generator_ColumnPropNameInTable="ThanhTienGiaBiaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TenKho" msprop:Generator_UserColumnName="TenKho" msprop:Generator_ColumnPropNameInRow="TenKho" msprop:Generator_ColumnVarNameInTable="columnTenKho" msprop:Generator_ColumnPropNameInTable="TenKhoColumn" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SoDuTaiKhoan" />
      <xs:field xpath="mstns:ThoiDiemKhoaSoID" />
      <xs:field xpath="mstns:TaiKhoanID" />
    </xs:unique>
    <xs:unique name="SoDuNgoaiTe_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SoDuNgoaiTe" />
      <xs:field xpath="mstns:ThoiDiemKhoaSoID" />
      <xs:field xpath="mstns:TaiKhoanID" />
      <xs:field xpath="mstns:TienTeID" />
    </xs:unique>
    <xs:unique name="SoDuTheoDoiTuong_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SoDuTheoDoiTuong" />
      <xs:field xpath="mstns:ThoiDiemKhoaSoID" />
      <xs:field xpath="mstns:TaiKhoanID" />
      <xs:field xpath="mstns:DoiTuongNghiepVuID" />
    </xs:unique>
    <xs:unique name="ThoiDiemKhoaSo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ThoiDiemKhoaSo" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TonKho_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TonKho" />
      <xs:field xpath="mstns:ThoiDiemKhoaSoID" />
      <xs:field xpath="mstns:KhoID" />
      <xs:field xpath="mstns:VatTuHangHoaID" />
    </xs:unique>
  </xs:element>
</xs:schema>